Select a database you want query patroller to intercept 選擇query patroller要截獲的數(shù)據(jù)庫(kù)。
User to create query patroller tables 從遠(yuǎn)程登錄會(huì)話,使用
For example , the location i used for db2 query patroller is 例如,我使用的db2 query patroller的位置是
Configuration parameter on query patroller managed databases on all partitions 在所有分區(qū)中query patroller管理的數(shù)據(jù)庫(kù)中啟用
To create query patroller control tables and register a target tablespace to store query result tables 創(chuàng)建query patroller控制表并注冊(cè)目標(biāo)表空間來存儲(chǔ)查詢結(jié)果表。
Table space should be created on a single database partition groups on the same partition where you run query patroller server 表空間應(yīng)該創(chuàng)建在您運(yùn)行query patroller server的同一分區(qū)中的單個(gè)數(shù)據(jù)庫(kù)分區(qū)組中。
You may install db2 query patroller on one or more computers ; each query patroller server may be used to manage different databases 您可以在一臺(tái)或多臺(tái)計(jì)算機(jī)中安裝db2 query patroller ;每臺(tái)query patroller服務(wù)器可以用于管理不同的數(shù)據(jù)庫(kù)。
Therefore , you may want to create table spaces for query patroller using create tablespace if you want to have a different page size and more than one containers 因此,如果想要不同的頁(yè)大小或多個(gè)容器,可以使用create tablespace為query patroller創(chuàng)建表空間。
This frees up some resources on that partition so it can be used as a coordinator partition or to run db2 warehouse manager and query patroller server 這將釋放該分區(qū)中的一些資源,從而它可以用作協(xié)調(diào)程序分區(qū)或用于運(yùn)行db2 warehouse manager和query patroller服務(wù)器。
Db2 query patroller can be installed and run on any partition server preferably a server with extra resources , such as a coordinator partition that contains small amount of data Db2 query patroller可以在任何分區(qū)服務(wù)器(具有額外資源的服務(wù)器更好,如包含少量數(shù)據(jù)的協(xié)調(diào)程序分區(qū))上安裝和運(yùn)行。